| StaffGroup |
| EntityType | Independent |
| Logical Entity Name | StaffGroup |
| Default Table Name | SyStaffGroup |
| Logical Only | NO |
| Definition | |
| Note |
| StaffGroup Attributes |
| Attribute/Logical Rolename | Domain | Datatype | NULL | Definition |
| Code | CHAR(8) | NO | ||
| Name | VARCHAR(40) | NO | ||
| IsActive | BIT | NO | ||
| ModFlag | CHAR(1) | NO | ||
| IsSystemCode | BIT | NO | ||
| LastModifiedUserId | INTEGER | NO | ||
| CreatedDateTime | DATETIME | NO | ||
| LastModifiedDateTime | DATETIME | YES | ||
| RowVersion | TIMESTAMP/DATE | NO | ||
StaffGroupId |
INTEGER | NO | ||
| IsRequiredForEnroll | BIT | NO | ||
AdvisorModule |
CHAR(8) | YES | ||
| CanOverrideLeadDuplicateWarning | BIT | NO | ||
| GroupType | CHAR(4) | YES | ||
| AllowDropLDAAttendChange | BIT | NO | ||
| IsCampusLinkAmbassadorUse | BIT | NO | ||
| IsPositivePayUse | BIT | NO | ||
| IsExcludedCrmIntegration | BIT | NO |
| StaffGroup Keys |
| Key Name | Key Type | Keys |
| SyStaffGroup_AdvisorModule_N_N_IDX | Inversion Entry | AdvisorModule |
| SyStaffGroup_Code_N_N_IDX | Inversion Entry | Code |
| SyStaffGroup_SyStaffGroupID_U_C_IDX | PrimaryKey | StaffGroupId |
| StaffGroup Relationships |
| Parent Relationships: |
| Entity Name | Type | Cardinality | Business Name | VerbPhrase | InversePhrase | Foreign Keys | Is Supertype |
| Module | Non-Identifying | Zero or One to Zero or More | AdvisorModule | NO |
| Child Relationships: |
| Entity Name | Type | Cardinality | Business Name | VerbPhrase | InversePhrase | Foreign Keys | Is Subtype |
| StudentAdvisor | Non-Identifying | Zero or One to Zero or More | NO | ||||
| TaskAddTrigger | Non-Identifying | One To Zero or More | NO | ||||
| cmStaffGroupAccess | Non-Identifying | One To Zero or More | NO | ||||
| AutoAwardPaymentPlanSetting | Non-Identifying | One To Zero or More | NO | ||||
| FaCashPlanWorkflowAudit | Non-Identifying | One To Zero or More | NO | ||||
| FaCashPlanWorkflowAudit | Non-Identifying | One To Zero or More | NO | ||||
| StudentAwardPromNotePrintAssignment | Non-Identifying | One To Zero or More | NO | ||||
| FaPromNotePrintAudit | Non-Identifying | One To Zero or More | NO | ||||
| FaPromNotePrintAudit | Non-Identifying | One To Zero or More | NO | ||||
| FaStudentAidCashPlanAssignment | Non-Identifying | One To Zero or More | NO | ||||
| AchBatchFileSetting | Non-Identifying | One To Zero or More | NO | ||||
| BillingTransactionCodeStaffGroup | Non-Identifying | One To Zero or More | NO | ||||
| DisbursementReceiptNotification | Non-Identifying | One To Zero or More | NO | ||||
| StudentRt4CalculationPostWithdrawalDisbursementAssignment | Non-Identifying | One To Zero or More | NO | ||||
| PostWithdrawalDisbursementConfigurationDetail | Non-Identifying | One To Zero or More | NO | ||||
| SaPWDRoutingTemplate | Non-Identifying | One To Zero or More | NO | ||||
| SaRefundCalculationAssignment | Non-Identifying | One To Zero or More | NO | ||||
| SaRefundCalculationRoutingTemplate | Non-Identifying | One To Zero or More | NO | ||||
| SaRefundCalculationWorkflowAudit | Non-Identifying | One To Zero or More | NO | ||||
| SaRefundCalculationWorkflowAudit | Non-Identifying | One To Zero or More | NO | ||||
| SaReturnOfT4Assignment | Non-Identifying | One To Zero or More | NO | ||||
| StudentRt4CalculationPostWithdrawalDisbursementAssignmentDataChange | Non-Identifying | One To Zero or More | NO | ||||
| StudentRt4CalculationPostWithdrawalDisbursementAssignmentDataChange | Non-Identifying | One To Zero or More | NO | ||||
| StudentAccountTransactionPendingCheck | Non-Identifying | One To Zero or More | NO | ||||
| Si_Packages_Security | Non-Identifying | One To Zero or More | NO | ||||
| CampusDefaultStudentAdvisor | Identifying | One To Zero or More | NO | ||||
| EmployerContactTypeStaffGroup | Non-Identifying | One To Zero or More | NO | ||||
| StaffGroupFundSourcePermission | Non-Identifying | One To Zero or More | NO | ||||
| SchoolStatusDetailStaffGroup | Identifying | One To Zero or More | NO | ||||
| SecurityMenuAuthorization | Non-Identifying | One To Zero or More | NO | ||||
| FaaProcessExceptionAssignment | Non-Identifying | One To Zero or More | NO | ||||
| FaaProcessExceptionAssignment | Non-Identifying | One To Zero or More | NO | ||||
| FaaProcessExceptionDataChange | Non-Identifying | One To Zero or More | NO | ||||
| FaaProcessExceptionDataChange | Non-Identifying | One To Zero or More | NO | ||||
| FaaProcessExceptionDataChange | Non-Identifying | One To Zero or More | NO | ||||
| FaaProcessExceptionDataChange | Non-Identifying | One To Zero or More | NO | ||||
| FaaProcessExceptionTypeCampusTemplate | Non-Identifying | One To Zero or More | NO | ||||
| FaaProcessExceptionCustomActionDocumentReview | Non-Identifying | One To Zero or More | NO | ||||
| FaaProcessExceptionOverrideUser | Non-Identifying | One To Zero or More | NO | ||||
| FaaProcessExceptionSearchFilterUser | Non-Identifying | One To Zero or More | NO | ||||
| FaaProcessExceptionTypeTemplate | Non-Identifying | One To Zero or More | NO | ||||
| SyServiceNotificationTemplateAssignment | Non-Identifying | One To Zero or More | NO | ||||
| SyServicePerformanceGoalsAssignment | Non-Identifying | One To Zero or More | NO | ||||
| FaaStaffGroupDelegation | Non-Identifying | One To Zero or More | NO | ||||
| FaaStaffGroupHierarchy | Non-Identifying | One To Zero or More | NO | ||||
| FaaStaffGroupHierarchy | Non-Identifying | One To Zero or More | NO | ||||
| StaffGroupMember | Non-Identifying | One To Zero or More | NO | ||||
| StaffGroupRefreshRule | Non-Identifying | One To Zero or More | NO | ||||
| StaffGroupTemplateSetting | Non-Identifying | One To Zero or More | NO | ||||
| SyStatusGridStaffGroup | Identifying | One To Zero or More | NO | ||||
| WorkspaceStaffGroup | Non-Identifying | One To Zero or More | NO | ||||
| EmployerContactTypeStaffGroup | Non-Identifying | One To Zero or More | NO | ||||
| StudentAdvisorDataChange | Non-Identifying | One To Zero or More | NO | ||||
| TaskPolicyDetail | Non-Identifying | One To Zero or More | NO |
| StaffGroup Check Constraints |
| Check Constraint Name | CheckConstraint |